home *** CD-ROM | disk | FTP | other *** search
- 3DBF
- ░░░░░░░░░░░░░░░░░░░░░░░
- ░ CREATING A DATABASE ░
- ░░░░░░░░░░░░░░░░░░░░░░░
-
- Notice there are four highlighted-columns that
- are to be filled in, they are:
-
- Field Name Type Width Dec
- ══════════════════════════════════════════
- █████████████ █████████ ████ ████
-
-
- √√√ WHAT THESE COLUMNS MEAN
- Field_Names:
- Each field needs a name.
- The name could have up to 10 characters.
- You can use the Underscore (_) to separate
- words, but not spaces.
-
- An example of using Underscore to separate words.
-
- LAST_NAME ...This is OK.
- LAST NAME ...This is not acceptable.
-
- √√√ TYPE
- There are five types of information that can be stored
- in this Field. To make a selection press the SPACEBAR.
-
- √√√ CHARACTER
- Letters, punctuation marks, numbers that are
- going to be printed, but are NOT going to be used in
- mathematical calculations.
-
- √√√ NUMERIC
- Numbers that will be used in mathematical calculations,
- such as dollar amounts.
-
- √√√ LOGICAL
- For true/false or yes/no data.
-
- √√√ DATE
- Dates only--such as 10/10/92.
-
- √√√ MEMO
- Here you can store varying amounts of text
- or each record. For example some notes about
- the person in the record.
-
- √√√ WIDTH
- Used for setting the least number of spaces
- you will need for letters and numbers you plan to put in
- a field.
-
- √√√ Logical
- Date, and Memo are automatically assigned a width.
-
- √√√ DEC
- If you are defining a NUMERIC field you must indicate
- the the number of spaces. For monetary figures, you
- would type in 2 for dollar and cents.
- =============
- -1-
-
-
-
-
-
- ░░░░░░░░░░░░░░░░░░░░░░░░
- ░ TYPING IN THE FIELDS ░
- ░░░░░░░░░░░░░░░░░░░░░░░░
-
- Field Name Type Width Dec
-
- ========================================
- ======
- 1. LAST_NAME CHARACTER 12 ---
- 2. FIRST_NAME CHARACTER 10 ---
- 3. STREET CHARACTER 15 ---
- 4. CITY CHARACTER 10 ---
- 5. STATE CHARACTER 2 ---
- 6. ZIP_CODE CHARACTER 5 ---
- 7. DUES_PAID NUMERIC 6 2
-
-
- √√√ HOW TO SAVE THE DATABASE
- Press and hold down the Control <Ctrl> key...then press
- the <END> key. Your database is saved with the name MEMBERS.
- PRESS ENTER TO CONFIRM.
-
- Screen now asks "Input Data Records Now? Press Y for Yes.
-
-
- ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
- ░THE DATABASE STRUCTURE APPEARS ON THE SCREEN░
- ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
-
- LAST_Name ██████████████
- FIRST_NAME ███████████
- Street ███████████████
- CITY ███████████
- STATE ███
- ZIP_CODE ███████
- DUES_PAID █████████
-
-
-
- √√√ ADDING DATA (MEMBERS NAMES) TO THE DATABASE
- Type the following five MEMBERS into the database (above)
- in the spaces provided. After each entry, press the <Enter>
- key to move to the next column of the database.
-
-
- LAST_NAME FIRST_NAME STREET CITY STATE ZIP Dues_Paid
- -----------------------------------------------------------------
- CHAMBERS NEIL 386 JACKSON ST MIAMI FL 33310 25.00
- JENSEN HOWARD 4654 ONEIDA ST PITTSFORD NY 14534 25.00
- KANTON JANE 90 FIRST ROAD NEW YORK NY 10011 15.00
- MICHAELS MARY 13 DOBBY LANE CHANDLER AZ 85225 25.00
- SMITH FRANK 55 COAST ROAD EAGLE CRK OR 97022 10.00
-
-
-
-
- SEE NEXT PAGE FOR SAMPLE DATABASE
-
-
-
-
- -2-
-
-
-
-
-
- ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
- ░ SAMPLE ░░░░░░░░░░░░░░░░░░░░░
- ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
- ░ LAST_NAME CHAMBERS ░
- ░ FIRST_NAME NEIL ░
- ░ STREET 386 JACKSON ST ░
- ░ CITY MIAMI ░
- ░ STATE FL ░
- ░ ZIP 33310 ░
- ░ DUES PAID 25.00 ░
- ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
-
-
-
-
-
-
- *** END OF CHAPTER ***
-
- Press <ESC> key to return to Menu.
-
- Select "OPENING A DATATBASE", then press <Enter> key.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- -10-
-